package sopt.dev.db;

import static sopt.dev.db.ItemInfoDB.ItemDBScheme;

/**
 * Created by Dev on 13. 8. 3.
 */
public class ItemDBCreator implements IDBCreator {


	@Override
	public String[] getCreateTableStmt() {

		/*
    Create table : DDL
		 */
		final String ITEM_TABLE_CREATE_STMT = "CREATE TABLE "
				+ ItemDBScheme.TABLE_NAME + " ("
				+ ItemDBScheme.COLUMN_ID + " INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "
				+ ItemDBScheme.COLUMN_CITYNAME + " TEXT ,"
				+ ItemDBScheme.COLUMN_NAME + " TEXT, "
				+ ItemDBScheme.COLUMN_DATE + " TEXT, "
				+ ItemDBScheme.COLUMN_TYPE + " INTEGER, "
				+ ItemDBScheme.COLUMN_PRICE + " INTEGER, "
				+ ItemDBScheme.COLUMN_IMGPATH + "TEXT, "
				+ ItemDBScheme.COLUMN_LATITUDE+ "DOUBLE, "
				+ ItemDBScheme.COLUMN_LONGTITUDE+ "DOUBLE,"
				+ ItemDBScheme.COLUMN_COMMENT + "TEXT, "
				+ ItemDBScheme.COLUMN_PAYTYPE + " INTEGER );";

		return new String[]{ITEM_TABLE_CREATE_STMT};
	}

	@Override
	public String[] getInitDataStmt() {
		return new String[0];
	}
}
